package com.rc.saas.mini.model.tenant;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TenantTransferExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TenantTransferExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andTransferIdIsNull() {
            addCriterion("transfer_id is null");
            return (Criteria) this;
        }

        public Criteria andTransferIdIsNotNull() {
            addCriterion("transfer_id is not null");
            return (Criteria) this;
        }

        public Criteria andTransferIdEqualTo(Long value) {
            addCriterion("transfer_id =", value, "transferId");
            return (Criteria) this;
        }

        public Criteria andTransferIdNotEqualTo(Long value) {
            addCriterion("transfer_id <>", value, "transferId");
            return (Criteria) this;
        }

        public Criteria andTransferIdGreaterThan(Long value) {
            addCriterion("transfer_id >", value, "transferId");
            return (Criteria) this;
        }

        public Criteria andTransferIdGreaterThanOrEqualTo(Long value) {
            addCriterion("transfer_id >=", value, "transferId");
            return (Criteria) this;
        }

        public Criteria andTransferIdLessThan(Long value) {
            addCriterion("transfer_id <", value, "transferId");
            return (Criteria) this;
        }

        public Criteria andTransferIdLessThanOrEqualTo(Long value) {
            addCriterion("transfer_id <=", value, "transferId");
            return (Criteria) this;
        }

        public Criteria andTransferIdIn(List<Long> values) {
            addCriterion("transfer_id in", values, "transferId");
            return (Criteria) this;
        }

        public Criteria andTransferIdNotIn(List<Long> values) {
            addCriterion("transfer_id not in", values, "transferId");
            return (Criteria) this;
        }

        public Criteria andTransferIdBetween(Long value1, Long value2) {
            addCriterion("transfer_id between", value1, value2, "transferId");
            return (Criteria) this;
        }

        public Criteria andTransferIdNotBetween(Long value1, Long value2) {
            addCriterion("transfer_id not between", value1, value2, "transferId");
            return (Criteria) this;
        }

        public Criteria andTenantCodeIsNull() {
            addCriterion("tenant_code is null");
            return (Criteria) this;
        }

        public Criteria andTenantCodeIsNotNull() {
            addCriterion("tenant_code is not null");
            return (Criteria) this;
        }

        public Criteria andTenantCodeEqualTo(String value) {
            addCriterion("tenant_code =", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeNotEqualTo(String value) {
            addCriterion("tenant_code <>", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeGreaterThan(String value) {
            addCriterion("tenant_code >", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeGreaterThanOrEqualTo(String value) {
            addCriterion("tenant_code >=", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeLessThan(String value) {
            addCriterion("tenant_code <", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeLessThanOrEqualTo(String value) {
            addCriterion("tenant_code <=", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeLike(String value) {
            addCriterion("tenant_code like", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeNotLike(String value) {
            addCriterion("tenant_code not like", value, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeIn(List<String> values) {
            addCriterion("tenant_code in", values, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeNotIn(List<String> values) {
            addCriterion("tenant_code not in", values, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeBetween(String value1, String value2) {
            addCriterion("tenant_code between", value1, value2, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andTenantCodeNotBetween(String value1, String value2) {
            addCriterion("tenant_code not between", value1, value2, "tenantCode");
            return (Criteria) this;
        }

        public Criteria andMemberMonthTransferMaxIsNull() {
            addCriterion("member_month_transfer_max is null");
            return (Criteria) this;
        }

        public Criteria andMemberMonthTransferMaxIsNotNull() {
            addCriterion("member_month_transfer_max is not null");
            return (Criteria) this;
        }

        public Criteria andMemberMonthTransferMaxEqualTo(Integer value) {
            addCriterion("member_month_transfer_max =", value, "memberMonthTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberMonthTransferMaxNotEqualTo(Integer value) {
            addCriterion("member_month_transfer_max <>", value, "memberMonthTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberMonthTransferMaxGreaterThan(Integer value) {
            addCriterion("member_month_transfer_max >", value, "memberMonthTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberMonthTransferMaxGreaterThanOrEqualTo(Integer value) {
            addCriterion("member_month_transfer_max >=", value, "memberMonthTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberMonthTransferMaxLessThan(Integer value) {
            addCriterion("member_month_transfer_max <", value, "memberMonthTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberMonthTransferMaxLessThanOrEqualTo(Integer value) {
            addCriterion("member_month_transfer_max <=", value, "memberMonthTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberMonthTransferMaxIn(List<Integer> values) {
            addCriterion("member_month_transfer_max in", values, "memberMonthTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberMonthTransferMaxNotIn(List<Integer> values) {
            addCriterion("member_month_transfer_max not in", values, "memberMonthTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberMonthTransferMaxBetween(Integer value1, Integer value2) {
            addCriterion("member_month_transfer_max between", value1, value2, "memberMonthTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberMonthTransferMaxNotBetween(Integer value1, Integer value2) {
            addCriterion("member_month_transfer_max not between", value1, value2, "memberMonthTransferMax");
            return (Criteria) this;
        }

        public Criteria andShowForWxIsNull() {
            addCriterion("show_for_wx is null");
            return (Criteria) this;
        }

        public Criteria andShowForWxIsNotNull() {
            addCriterion("show_for_wx is not null");
            return (Criteria) this;
        }

        public Criteria andShowForWxEqualTo(String value) {
            addCriterion("show_for_wx =", value, "showForWx");
            return (Criteria) this;
        }

        public Criteria andShowForWxNotEqualTo(String value) {
            addCriterion("show_for_wx <>", value, "showForWx");
            return (Criteria) this;
        }

        public Criteria andShowForWxGreaterThan(String value) {
            addCriterion("show_for_wx >", value, "showForWx");
            return (Criteria) this;
        }

        public Criteria andShowForWxGreaterThanOrEqualTo(String value) {
            addCriterion("show_for_wx >=", value, "showForWx");
            return (Criteria) this;
        }

        public Criteria andShowForWxLessThan(String value) {
            addCriterion("show_for_wx <", value, "showForWx");
            return (Criteria) this;
        }

        public Criteria andShowForWxLessThanOrEqualTo(String value) {
            addCriterion("show_for_wx <=", value, "showForWx");
            return (Criteria) this;
        }

        public Criteria andShowForWxLike(String value) {
            addCriterion("show_for_wx like", value, "showForWx");
            return (Criteria) this;
        }

        public Criteria andShowForWxNotLike(String value) {
            addCriterion("show_for_wx not like", value, "showForWx");
            return (Criteria) this;
        }

        public Criteria andShowForWxIn(List<String> values) {
            addCriterion("show_for_wx in", values, "showForWx");
            return (Criteria) this;
        }

        public Criteria andShowForWxNotIn(List<String> values) {
            addCriterion("show_for_wx not in", values, "showForWx");
            return (Criteria) this;
        }

        public Criteria andShowForWxBetween(String value1, String value2) {
            addCriterion("show_for_wx between", value1, value2, "showForWx");
            return (Criteria) this;
        }

        public Criteria andShowForWxNotBetween(String value1, String value2) {
            addCriterion("show_for_wx not between", value1, value2, "showForWx");
            return (Criteria) this;
        }

        public Criteria andShowForAppIsNull() {
            addCriterion("show_for_app is null");
            return (Criteria) this;
        }

        public Criteria andShowForAppIsNotNull() {
            addCriterion("show_for_app is not null");
            return (Criteria) this;
        }

        public Criteria andShowForAppEqualTo(String value) {
            addCriterion("show_for_app =", value, "showForApp");
            return (Criteria) this;
        }

        public Criteria andShowForAppNotEqualTo(String value) {
            addCriterion("show_for_app <>", value, "showForApp");
            return (Criteria) this;
        }

        public Criteria andShowForAppGreaterThan(String value) {
            addCriterion("show_for_app >", value, "showForApp");
            return (Criteria) this;
        }

        public Criteria andShowForAppGreaterThanOrEqualTo(String value) {
            addCriterion("show_for_app >=", value, "showForApp");
            return (Criteria) this;
        }

        public Criteria andShowForAppLessThan(String value) {
            addCriterion("show_for_app <", value, "showForApp");
            return (Criteria) this;
        }

        public Criteria andShowForAppLessThanOrEqualTo(String value) {
            addCriterion("show_for_app <=", value, "showForApp");
            return (Criteria) this;
        }

        public Criteria andShowForAppLike(String value) {
            addCriterion("show_for_app like", value, "showForApp");
            return (Criteria) this;
        }

        public Criteria andShowForAppNotLike(String value) {
            addCriterion("show_for_app not like", value, "showForApp");
            return (Criteria) this;
        }

        public Criteria andShowForAppIn(List<String> values) {
            addCriterion("show_for_app in", values, "showForApp");
            return (Criteria) this;
        }

        public Criteria andShowForAppNotIn(List<String> values) {
            addCriterion("show_for_app not in", values, "showForApp");
            return (Criteria) this;
        }

        public Criteria andShowForAppBetween(String value1, String value2) {
            addCriterion("show_for_app between", value1, value2, "showForApp");
            return (Criteria) this;
        }

        public Criteria andShowForAppNotBetween(String value1, String value2) {
            addCriterion("show_for_app not between", value1, value2, "showForApp");
            return (Criteria) this;
        }

        public Criteria andTransferForWxIsNull() {
            addCriterion("transfer_for_wx is null");
            return (Criteria) this;
        }

        public Criteria andTransferForWxIsNotNull() {
            addCriterion("transfer_for_wx is not null");
            return (Criteria) this;
        }

        public Criteria andTransferForWxEqualTo(String value) {
            addCriterion("transfer_for_wx =", value, "transferForWx");
            return (Criteria) this;
        }

        public Criteria andTransferForWxNotEqualTo(String value) {
            addCriterion("transfer_for_wx <>", value, "transferForWx");
            return (Criteria) this;
        }

        public Criteria andTransferForWxGreaterThan(String value) {
            addCriterion("transfer_for_wx >", value, "transferForWx");
            return (Criteria) this;
        }

        public Criteria andTransferForWxGreaterThanOrEqualTo(String value) {
            addCriterion("transfer_for_wx >=", value, "transferForWx");
            return (Criteria) this;
        }

        public Criteria andTransferForWxLessThan(String value) {
            addCriterion("transfer_for_wx <", value, "transferForWx");
            return (Criteria) this;
        }

        public Criteria andTransferForWxLessThanOrEqualTo(String value) {
            addCriterion("transfer_for_wx <=", value, "transferForWx");
            return (Criteria) this;
        }

        public Criteria andTransferForWxLike(String value) {
            addCriterion("transfer_for_wx like", value, "transferForWx");
            return (Criteria) this;
        }

        public Criteria andTransferForWxNotLike(String value) {
            addCriterion("transfer_for_wx not like", value, "transferForWx");
            return (Criteria) this;
        }

        public Criteria andTransferForWxIn(List<String> values) {
            addCriterion("transfer_for_wx in", values, "transferForWx");
            return (Criteria) this;
        }

        public Criteria andTransferForWxNotIn(List<String> values) {
            addCriterion("transfer_for_wx not in", values, "transferForWx");
            return (Criteria) this;
        }

        public Criteria andTransferForWxBetween(String value1, String value2) {
            addCriterion("transfer_for_wx between", value1, value2, "transferForWx");
            return (Criteria) this;
        }

        public Criteria andTransferForWxNotBetween(String value1, String value2) {
            addCriterion("transfer_for_wx not between", value1, value2, "transferForWx");
            return (Criteria) this;
        }

        public Criteria andTransferForAlipayIsNull() {
            addCriterion("transfer_for_alipay is null");
            return (Criteria) this;
        }

        public Criteria andTransferForAlipayIsNotNull() {
            addCriterion("transfer_for_alipay is not null");
            return (Criteria) this;
        }

        public Criteria andTransferForAlipayEqualTo(String value) {
            addCriterion("transfer_for_alipay =", value, "transferForAlipay");
            return (Criteria) this;
        }

        public Criteria andTransferForAlipayNotEqualTo(String value) {
            addCriterion("transfer_for_alipay <>", value, "transferForAlipay");
            return (Criteria) this;
        }

        public Criteria andTransferForAlipayGreaterThan(String value) {
            addCriterion("transfer_for_alipay >", value, "transferForAlipay");
            return (Criteria) this;
        }

        public Criteria andTransferForAlipayGreaterThanOrEqualTo(String value) {
            addCriterion("transfer_for_alipay >=", value, "transferForAlipay");
            return (Criteria) this;
        }

        public Criteria andTransferForAlipayLessThan(String value) {
            addCriterion("transfer_for_alipay <", value, "transferForAlipay");
            return (Criteria) this;
        }

        public Criteria andTransferForAlipayLessThanOrEqualTo(String value) {
            addCriterion("transfer_for_alipay <=", value, "transferForAlipay");
            return (Criteria) this;
        }

        public Criteria andTransferForAlipayLike(String value) {
            addCriterion("transfer_for_alipay like", value, "transferForAlipay");
            return (Criteria) this;
        }

        public Criteria andTransferForAlipayNotLike(String value) {
            addCriterion("transfer_for_alipay not like", value, "transferForAlipay");
            return (Criteria) this;
        }

        public Criteria andTransferForAlipayIn(List<String> values) {
            addCriterion("transfer_for_alipay in", values, "transferForAlipay");
            return (Criteria) this;
        }

        public Criteria andTransferForAlipayNotIn(List<String> values) {
            addCriterion("transfer_for_alipay not in", values, "transferForAlipay");
            return (Criteria) this;
        }

        public Criteria andTransferForAlipayBetween(String value1, String value2) {
            addCriterion("transfer_for_alipay between", value1, value2, "transferForAlipay");
            return (Criteria) this;
        }

        public Criteria andTransferForAlipayNotBetween(String value1, String value2) {
            addCriterion("transfer_for_alipay not between", value1, value2, "transferForAlipay");
            return (Criteria) this;
        }

        public Criteria andTransferForBankcardIsNull() {
            addCriterion("transfer_for_bankcard is null");
            return (Criteria) this;
        }

        public Criteria andTransferForBankcardIsNotNull() {
            addCriterion("transfer_for_bankcard is not null");
            return (Criteria) this;
        }

        public Criteria andTransferForBankcardEqualTo(String value) {
            addCriterion("transfer_for_bankcard =", value, "transferForBankcard");
            return (Criteria) this;
        }

        public Criteria andTransferForBankcardNotEqualTo(String value) {
            addCriterion("transfer_for_bankcard <>", value, "transferForBankcard");
            return (Criteria) this;
        }

        public Criteria andTransferForBankcardGreaterThan(String value) {
            addCriterion("transfer_for_bankcard >", value, "transferForBankcard");
            return (Criteria) this;
        }

        public Criteria andTransferForBankcardGreaterThanOrEqualTo(String value) {
            addCriterion("transfer_for_bankcard >=", value, "transferForBankcard");
            return (Criteria) this;
        }

        public Criteria andTransferForBankcardLessThan(String value) {
            addCriterion("transfer_for_bankcard <", value, "transferForBankcard");
            return (Criteria) this;
        }

        public Criteria andTransferForBankcardLessThanOrEqualTo(String value) {
            addCriterion("transfer_for_bankcard <=", value, "transferForBankcard");
            return (Criteria) this;
        }

        public Criteria andTransferForBankcardLike(String value) {
            addCriterion("transfer_for_bankcard like", value, "transferForBankcard");
            return (Criteria) this;
        }

        public Criteria andTransferForBankcardNotLike(String value) {
            addCriterion("transfer_for_bankcard not like", value, "transferForBankcard");
            return (Criteria) this;
        }

        public Criteria andTransferForBankcardIn(List<String> values) {
            addCriterion("transfer_for_bankcard in", values, "transferForBankcard");
            return (Criteria) this;
        }

        public Criteria andTransferForBankcardNotIn(List<String> values) {
            addCriterion("transfer_for_bankcard not in", values, "transferForBankcard");
            return (Criteria) this;
        }

        public Criteria andTransferForBankcardBetween(String value1, String value2) {
            addCriterion("transfer_for_bankcard between", value1, value2, "transferForBankcard");
            return (Criteria) this;
        }

        public Criteria andTransferForBankcardNotBetween(String value1, String value2) {
            addCriterion("transfer_for_bankcard not between", value1, value2, "transferForBankcard");
            return (Criteria) this;
        }

        public Criteria andTransferTypeIsNull() {
            addCriterion("transfer_type is null");
            return (Criteria) this;
        }

        public Criteria andTransferTypeIsNotNull() {
            addCriterion("transfer_type is not null");
            return (Criteria) this;
        }

        public Criteria andTransferTypeEqualTo(String value) {
            addCriterion("transfer_type =", value, "transferType");
            return (Criteria) this;
        }

        public Criteria andTransferTypeNotEqualTo(String value) {
            addCriterion("transfer_type <>", value, "transferType");
            return (Criteria) this;
        }

        public Criteria andTransferTypeGreaterThan(String value) {
            addCriterion("transfer_type >", value, "transferType");
            return (Criteria) this;
        }

        public Criteria andTransferTypeGreaterThanOrEqualTo(String value) {
            addCriterion("transfer_type >=", value, "transferType");
            return (Criteria) this;
        }

        public Criteria andTransferTypeLessThan(String value) {
            addCriterion("transfer_type <", value, "transferType");
            return (Criteria) this;
        }

        public Criteria andTransferTypeLessThanOrEqualTo(String value) {
            addCriterion("transfer_type <=", value, "transferType");
            return (Criteria) this;
        }

        public Criteria andTransferTypeLike(String value) {
            addCriterion("transfer_type like", value, "transferType");
            return (Criteria) this;
        }

        public Criteria andTransferTypeNotLike(String value) {
            addCriterion("transfer_type not like", value, "transferType");
            return (Criteria) this;
        }

        public Criteria andTransferTypeIn(List<String> values) {
            addCriterion("transfer_type in", values, "transferType");
            return (Criteria) this;
        }

        public Criteria andTransferTypeNotIn(List<String> values) {
            addCriterion("transfer_type not in", values, "transferType");
            return (Criteria) this;
        }

        public Criteria andTransferTypeBetween(String value1, String value2) {
            addCriterion("transfer_type between", value1, value2, "transferType");
            return (Criteria) this;
        }

        public Criteria andTransferTypeNotBetween(String value1, String value2) {
            addCriterion("transfer_type not between", value1, value2, "transferType");
            return (Criteria) this;
        }

        public Criteria andIsVerificationIsNull() {
            addCriterion("is_verification is null");
            return (Criteria) this;
        }

        public Criteria andIsVerificationIsNotNull() {
            addCriterion("is_verification is not null");
            return (Criteria) this;
        }

        public Criteria andIsVerificationEqualTo(String value) {
            addCriterion("is_verification =", value, "isVerification");
            return (Criteria) this;
        }

        public Criteria andIsVerificationNotEqualTo(String value) {
            addCriterion("is_verification <>", value, "isVerification");
            return (Criteria) this;
        }

        public Criteria andIsVerificationGreaterThan(String value) {
            addCriterion("is_verification >", value, "isVerification");
            return (Criteria) this;
        }

        public Criteria andIsVerificationGreaterThanOrEqualTo(String value) {
            addCriterion("is_verification >=", value, "isVerification");
            return (Criteria) this;
        }

        public Criteria andIsVerificationLessThan(String value) {
            addCriterion("is_verification <", value, "isVerification");
            return (Criteria) this;
        }

        public Criteria andIsVerificationLessThanOrEqualTo(String value) {
            addCriterion("is_verification <=", value, "isVerification");
            return (Criteria) this;
        }

        public Criteria andIsVerificationLike(String value) {
            addCriterion("is_verification like", value, "isVerification");
            return (Criteria) this;
        }

        public Criteria andIsVerificationNotLike(String value) {
            addCriterion("is_verification not like", value, "isVerification");
            return (Criteria) this;
        }

        public Criteria andIsVerificationIn(List<String> values) {
            addCriterion("is_verification in", values, "isVerification");
            return (Criteria) this;
        }

        public Criteria andIsVerificationNotIn(List<String> values) {
            addCriterion("is_verification not in", values, "isVerification");
            return (Criteria) this;
        }

        public Criteria andIsVerificationBetween(String value1, String value2) {
            addCriterion("is_verification between", value1, value2, "isVerification");
            return (Criteria) this;
        }

        public Criteria andIsVerificationNotBetween(String value1, String value2) {
            addCriterion("is_verification not between", value1, value2, "isVerification");
            return (Criteria) this;
        }

        public Criteria andMemberAutoTransferIsNull() {
            addCriterion("member_auto_transfer is null");
            return (Criteria) this;
        }

        public Criteria andMemberAutoTransferIsNotNull() {
            addCriterion("member_auto_transfer is not null");
            return (Criteria) this;
        }

        public Criteria andMemberAutoTransferEqualTo(String value) {
            addCriterion("member_auto_transfer =", value, "memberAutoTransfer");
            return (Criteria) this;
        }

        public Criteria andMemberAutoTransferNotEqualTo(String value) {
            addCriterion("member_auto_transfer <>", value, "memberAutoTransfer");
            return (Criteria) this;
        }

        public Criteria andMemberAutoTransferGreaterThan(String value) {
            addCriterion("member_auto_transfer >", value, "memberAutoTransfer");
            return (Criteria) this;
        }

        public Criteria andMemberAutoTransferGreaterThanOrEqualTo(String value) {
            addCriterion("member_auto_transfer >=", value, "memberAutoTransfer");
            return (Criteria) this;
        }

        public Criteria andMemberAutoTransferLessThan(String value) {
            addCriterion("member_auto_transfer <", value, "memberAutoTransfer");
            return (Criteria) this;
        }

        public Criteria andMemberAutoTransferLessThanOrEqualTo(String value) {
            addCriterion("member_auto_transfer <=", value, "memberAutoTransfer");
            return (Criteria) this;
        }

        public Criteria andMemberAutoTransferLike(String value) {
            addCriterion("member_auto_transfer like", value, "memberAutoTransfer");
            return (Criteria) this;
        }

        public Criteria andMemberAutoTransferNotLike(String value) {
            addCriterion("member_auto_transfer not like", value, "memberAutoTransfer");
            return (Criteria) this;
        }

        public Criteria andMemberAutoTransferIn(List<String> values) {
            addCriterion("member_auto_transfer in", values, "memberAutoTransfer");
            return (Criteria) this;
        }

        public Criteria andMemberAutoTransferNotIn(List<String> values) {
            addCriterion("member_auto_transfer not in", values, "memberAutoTransfer");
            return (Criteria) this;
        }

        public Criteria andMemberAutoTransferBetween(String value1, String value2) {
            addCriterion("member_auto_transfer between", value1, value2, "memberAutoTransfer");
            return (Criteria) this;
        }

        public Criteria andMemberAutoTransferNotBetween(String value1, String value2) {
            addCriterion("member_auto_transfer not between", value1, value2, "memberAutoTransfer");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMinIsNull() {
            addCriterion("member_transfer_min is null");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMinIsNotNull() {
            addCriterion("member_transfer_min is not null");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMinEqualTo(BigDecimal value) {
            addCriterion("member_transfer_min =", value, "memberTransferMin");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMinNotEqualTo(BigDecimal value) {
            addCriterion("member_transfer_min <>", value, "memberTransferMin");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMinGreaterThan(BigDecimal value) {
            addCriterion("member_transfer_min >", value, "memberTransferMin");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMinGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("member_transfer_min >=", value, "memberTransferMin");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMinLessThan(BigDecimal value) {
            addCriterion("member_transfer_min <", value, "memberTransferMin");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMinLessThanOrEqualTo(BigDecimal value) {
            addCriterion("member_transfer_min <=", value, "memberTransferMin");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMinIn(List<BigDecimal> values) {
            addCriterion("member_transfer_min in", values, "memberTransferMin");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMinNotIn(List<BigDecimal> values) {
            addCriterion("member_transfer_min not in", values, "memberTransferMin");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMinBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("member_transfer_min between", value1, value2, "memberTransferMin");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMinNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("member_transfer_min not between", value1, value2, "memberTransferMin");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMaxIsNull() {
            addCriterion("member_transfer_max is null");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMaxIsNotNull() {
            addCriterion("member_transfer_max is not null");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMaxEqualTo(BigDecimal value) {
            addCriterion("member_transfer_max =", value, "memberTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMaxNotEqualTo(BigDecimal value) {
            addCriterion("member_transfer_max <>", value, "memberTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMaxGreaterThan(BigDecimal value) {
            addCriterion("member_transfer_max >", value, "memberTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMaxGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("member_transfer_max >=", value, "memberTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMaxLessThan(BigDecimal value) {
            addCriterion("member_transfer_max <", value, "memberTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMaxLessThanOrEqualTo(BigDecimal value) {
            addCriterion("member_transfer_max <=", value, "memberTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMaxIn(List<BigDecimal> values) {
            addCriterion("member_transfer_max in", values, "memberTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMaxNotIn(List<BigDecimal> values) {
            addCriterion("member_transfer_max not in", values, "memberTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMaxBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("member_transfer_max between", value1, value2, "memberTransferMax");
            return (Criteria) this;
        }

        public Criteria andMemberTransferMaxNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("member_transfer_max not between", value1, value2, "memberTransferMax");
            return (Criteria) this;
        }

        public Criteria andTransferHintIsNull() {
            addCriterion("transfer_hint is null");
            return (Criteria) this;
        }

        public Criteria andTransferHintIsNotNull() {
            addCriterion("transfer_hint is not null");
            return (Criteria) this;
        }

        public Criteria andTransferHintEqualTo(String value) {
            addCriterion("transfer_hint =", value, "transferHint");
            return (Criteria) this;
        }

        public Criteria andTransferHintNotEqualTo(String value) {
            addCriterion("transfer_hint <>", value, "transferHint");
            return (Criteria) this;
        }

        public Criteria andTransferHintGreaterThan(String value) {
            addCriterion("transfer_hint >", value, "transferHint");
            return (Criteria) this;
        }

        public Criteria andTransferHintGreaterThanOrEqualTo(String value) {
            addCriterion("transfer_hint >=", value, "transferHint");
            return (Criteria) this;
        }

        public Criteria andTransferHintLessThan(String value) {
            addCriterion("transfer_hint <", value, "transferHint");
            return (Criteria) this;
        }

        public Criteria andTransferHintLessThanOrEqualTo(String value) {
            addCriterion("transfer_hint <=", value, "transferHint");
            return (Criteria) this;
        }

        public Criteria andTransferHintLike(String value) {
            addCriterion("transfer_hint like", value, "transferHint");
            return (Criteria) this;
        }

        public Criteria andTransferHintNotLike(String value) {
            addCriterion("transfer_hint not like", value, "transferHint");
            return (Criteria) this;
        }

        public Criteria andTransferHintIn(List<String> values) {
            addCriterion("transfer_hint in", values, "transferHint");
            return (Criteria) this;
        }

        public Criteria andTransferHintNotIn(List<String> values) {
            addCriterion("transfer_hint not in", values, "transferHint");
            return (Criteria) this;
        }

        public Criteria andTransferHintBetween(String value1, String value2) {
            addCriterion("transfer_hint between", value1, value2, "transferHint");
            return (Criteria) this;
        }

        public Criteria andTransferHintNotBetween(String value1, String value2) {
            addCriterion("transfer_hint not between", value1, value2, "transferHint");
            return (Criteria) this;
        }

        public Criteria andCreatedByIsNull() {
            addCriterion("created_by is null");
            return (Criteria) this;
        }

        public Criteria andCreatedByIsNotNull() {
            addCriterion("created_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedByEqualTo(String value) {
            addCriterion("created_by =", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotEqualTo(String value) {
            addCriterion("created_by <>", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByGreaterThan(String value) {
            addCriterion("created_by >", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByGreaterThanOrEqualTo(String value) {
            addCriterion("created_by >=", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByLessThan(String value) {
            addCriterion("created_by <", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByLessThanOrEqualTo(String value) {
            addCriterion("created_by <=", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByLike(String value) {
            addCriterion("created_by like", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotLike(String value) {
            addCriterion("created_by not like", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByIn(List<String> values) {
            addCriterion("created_by in", values, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotIn(List<String> values) {
            addCriterion("created_by not in", values, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByBetween(String value1, String value2) {
            addCriterion("created_by between", value1, value2, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotBetween(String value1, String value2) {
            addCriterion("created_by not between", value1, value2, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeIsNull() {
            addCriterion("created_time is null");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeIsNotNull() {
            addCriterion("created_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeEqualTo(Date value) {
            addCriterion("created_time =", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeNotEqualTo(Date value) {
            addCriterion("created_time <>", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeGreaterThan(Date value) {
            addCriterion("created_time >", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("created_time >=", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeLessThan(Date value) {
            addCriterion("created_time <", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeLessThanOrEqualTo(Date value) {
            addCriterion("created_time <=", value, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeIn(List<Date> values) {
            addCriterion("created_time in", values, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeNotIn(List<Date> values) {
            addCriterion("created_time not in", values, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeBetween(Date value1, Date value2) {
            addCriterion("created_time between", value1, value2, "createdTime");
            return (Criteria) this;
        }

        public Criteria andCreatedTimeNotBetween(Date value1, Date value2) {
            addCriterion("created_time not between", value1, value2, "createdTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByIsNull() {
            addCriterion("last_updated_by is null");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByIsNotNull() {
            addCriterion("last_updated_by is not null");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByEqualTo(String value) {
            addCriterion("last_updated_by =", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByNotEqualTo(String value) {
            addCriterion("last_updated_by <>", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByGreaterThan(String value) {
            addCriterion("last_updated_by >", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByGreaterThanOrEqualTo(String value) {
            addCriterion("last_updated_by >=", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByLessThan(String value) {
            addCriterion("last_updated_by <", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByLessThanOrEqualTo(String value) {
            addCriterion("last_updated_by <=", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByLike(String value) {
            addCriterion("last_updated_by like", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByNotLike(String value) {
            addCriterion("last_updated_by not like", value, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByIn(List<String> values) {
            addCriterion("last_updated_by in", values, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByNotIn(List<String> values) {
            addCriterion("last_updated_by not in", values, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByBetween(String value1, String value2) {
            addCriterion("last_updated_by between", value1, value2, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedByNotBetween(String value1, String value2) {
            addCriterion("last_updated_by not between", value1, value2, "lastUpdatedBy");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeIsNull() {
            addCriterion("last_updated_time is null");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeIsNotNull() {
            addCriterion("last_updated_time is not null");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeEqualTo(Date value) {
            addCriterion("last_updated_time =", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeNotEqualTo(Date value) {
            addCriterion("last_updated_time <>", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeGreaterThan(Date value) {
            addCriterion("last_updated_time >", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("last_updated_time >=", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeLessThan(Date value) {
            addCriterion("last_updated_time <", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeLessThanOrEqualTo(Date value) {
            addCriterion("last_updated_time <=", value, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeIn(List<Date> values) {
            addCriterion("last_updated_time in", values, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeNotIn(List<Date> values) {
            addCriterion("last_updated_time not in", values, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeBetween(Date value1, Date value2) {
            addCriterion("last_updated_time between", value1, value2, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdatedTimeNotBetween(Date value1, Date value2) {
            addCriterion("last_updated_time not between", value1, value2, "lastUpdatedTime");
            return (Criteria) this;
        }

        public Criteria andSingleMaxAmountIsNull() {
            addCriterion("single_max_amount is null");
            return (Criteria) this;
        }

        public Criteria andSingleMaxAmountIsNotNull() {
            addCriterion("single_max_amount is not null");
            return (Criteria) this;
        }

        public Criteria andSingleMaxAmountEqualTo(Long value) {
            addCriterion("single_max_amount =", value, "singleMaxAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMaxAmountNotEqualTo(Long value) {
            addCriterion("single_max_amount <>", value, "singleMaxAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMaxAmountGreaterThan(Long value) {
            addCriterion("single_max_amount >", value, "singleMaxAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMaxAmountGreaterThanOrEqualTo(Long value) {
            addCriterion("single_max_amount >=", value, "singleMaxAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMaxAmountLessThan(Long value) {
            addCriterion("single_max_amount <", value, "singleMaxAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMaxAmountLessThanOrEqualTo(Long value) {
            addCriterion("single_max_amount <=", value, "singleMaxAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMaxAmountIn(List<Long> values) {
            addCriterion("single_max_amount in", values, "singleMaxAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMaxAmountNotIn(List<Long> values) {
            addCriterion("single_max_amount not in", values, "singleMaxAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMaxAmountBetween(Long value1, Long value2) {
            addCriterion("single_max_amount between", value1, value2, "singleMaxAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMaxAmountNotBetween(Long value1, Long value2) {
            addCriterion("single_max_amount not between", value1, value2, "singleMaxAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMinAmountIsNull() {
            addCriterion("single_min_amount is null");
            return (Criteria) this;
        }

        public Criteria andSingleMinAmountIsNotNull() {
            addCriterion("single_min_amount is not null");
            return (Criteria) this;
        }

        public Criteria andSingleMinAmountEqualTo(Long value) {
            addCriterion("single_min_amount =", value, "singleMinAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMinAmountNotEqualTo(Long value) {
            addCriterion("single_min_amount <>", value, "singleMinAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMinAmountGreaterThan(Long value) {
            addCriterion("single_min_amount >", value, "singleMinAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMinAmountGreaterThanOrEqualTo(Long value) {
            addCriterion("single_min_amount >=", value, "singleMinAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMinAmountLessThan(Long value) {
            addCriterion("single_min_amount <", value, "singleMinAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMinAmountLessThanOrEqualTo(Long value) {
            addCriterion("single_min_amount <=", value, "singleMinAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMinAmountIn(List<Long> values) {
            addCriterion("single_min_amount in", values, "singleMinAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMinAmountNotIn(List<Long> values) {
            addCriterion("single_min_amount not in", values, "singleMinAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMinAmountBetween(Long value1, Long value2) {
            addCriterion("single_min_amount between", value1, value2, "singleMinAmount");
            return (Criteria) this;
        }

        public Criteria andSingleMinAmountNotBetween(Long value1, Long value2) {
            addCriterion("single_min_amount not between", value1, value2, "singleMinAmount");
            return (Criteria) this;
        }

        public Criteria andTodayTotalAmountIsNull() {
            addCriterion("today_total_amount is null");
            return (Criteria) this;
        }

        public Criteria andTodayTotalAmountIsNotNull() {
            addCriterion("today_total_amount is not null");
            return (Criteria) this;
        }

        public Criteria andTodayTotalAmountEqualTo(Long value) {
            addCriterion("today_total_amount =", value, "todayTotalAmount");
            return (Criteria) this;
        }

        public Criteria andTodayTotalAmountNotEqualTo(Long value) {
            addCriterion("today_total_amount <>", value, "todayTotalAmount");
            return (Criteria) this;
        }

        public Criteria andTodayTotalAmountGreaterThan(Long value) {
            addCriterion("today_total_amount >", value, "todayTotalAmount");
            return (Criteria) this;
        }

        public Criteria andTodayTotalAmountGreaterThanOrEqualTo(Long value) {
            addCriterion("today_total_amount >=", value, "todayTotalAmount");
            return (Criteria) this;
        }

        public Criteria andTodayTotalAmountLessThan(Long value) {
            addCriterion("today_total_amount <", value, "todayTotalAmount");
            return (Criteria) this;
        }

        public Criteria andTodayTotalAmountLessThanOrEqualTo(Long value) {
            addCriterion("today_total_amount <=", value, "todayTotalAmount");
            return (Criteria) this;
        }

        public Criteria andTodayTotalAmountIn(List<Long> values) {
            addCriterion("today_total_amount in", values, "todayTotalAmount");
            return (Criteria) this;
        }

        public Criteria andTodayTotalAmountNotIn(List<Long> values) {
            addCriterion("today_total_amount not in", values, "todayTotalAmount");
            return (Criteria) this;
        }

        public Criteria andTodayTotalAmountBetween(Long value1, Long value2) {
            addCriterion("today_total_amount between", value1, value2, "todayTotalAmount");
            return (Criteria) this;
        }

        public Criteria andTodayTotalAmountNotBetween(Long value1, Long value2) {
            addCriterion("today_total_amount not between", value1, value2, "todayTotalAmount");
            return (Criteria) this;
        }

        public Criteria andTodayTotalNumIsNull() {
            addCriterion("today_total_num is null");
            return (Criteria) this;
        }

        public Criteria andTodayTotalNumIsNotNull() {
            addCriterion("today_total_num is not null");
            return (Criteria) this;
        }

        public Criteria andTodayTotalNumEqualTo(Integer value) {
            addCriterion("today_total_num =", value, "todayTotalNum");
            return (Criteria) this;
        }

        public Criteria andTodayTotalNumNotEqualTo(Integer value) {
            addCriterion("today_total_num <>", value, "todayTotalNum");
            return (Criteria) this;
        }

        public Criteria andTodayTotalNumGreaterThan(Integer value) {
            addCriterion("today_total_num >", value, "todayTotalNum");
            return (Criteria) this;
        }

        public Criteria andTodayTotalNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("today_total_num >=", value, "todayTotalNum");
            return (Criteria) this;
        }

        public Criteria andTodayTotalNumLessThan(Integer value) {
            addCriterion("today_total_num <", value, "todayTotalNum");
            return (Criteria) this;
        }

        public Criteria andTodayTotalNumLessThanOrEqualTo(Integer value) {
            addCriterion("today_total_num <=", value, "todayTotalNum");
            return (Criteria) this;
        }

        public Criteria andTodayTotalNumIn(List<Integer> values) {
            addCriterion("today_total_num in", values, "todayTotalNum");
            return (Criteria) this;
        }

        public Criteria andTodayTotalNumNotIn(List<Integer> values) {
            addCriterion("today_total_num not in", values, "todayTotalNum");
            return (Criteria) this;
        }

        public Criteria andTodayTotalNumBetween(Integer value1, Integer value2) {
            addCriterion("today_total_num between", value1, value2, "todayTotalNum");
            return (Criteria) this;
        }

        public Criteria andTodayTotalNumNotBetween(Integer value1, Integer value2) {
            addCriterion("today_total_num not between", value1, value2, "todayTotalNum");
            return (Criteria) this;
        }

        public Criteria andUpperAmounyIsNull() {
            addCriterion("upper_amouny is null");
            return (Criteria) this;
        }

        public Criteria andUpperAmounyIsNotNull() {
            addCriterion("upper_amouny is not null");
            return (Criteria) this;
        }

        public Criteria andUpperAmounyEqualTo(Long value) {
            addCriterion("upper_amouny =", value, "upperAmouny");
            return (Criteria) this;
        }

        public Criteria andUpperAmounyNotEqualTo(Long value) {
            addCriterion("upper_amouny <>", value, "upperAmouny");
            return (Criteria) this;
        }

        public Criteria andUpperAmounyGreaterThan(Long value) {
            addCriterion("upper_amouny >", value, "upperAmouny");
            return (Criteria) this;
        }

        public Criteria andUpperAmounyGreaterThanOrEqualTo(Long value) {
            addCriterion("upper_amouny >=", value, "upperAmouny");
            return (Criteria) this;
        }

        public Criteria andUpperAmounyLessThan(Long value) {
            addCriterion("upper_amouny <", value, "upperAmouny");
            return (Criteria) this;
        }

        public Criteria andUpperAmounyLessThanOrEqualTo(Long value) {
            addCriterion("upper_amouny <=", value, "upperAmouny");
            return (Criteria) this;
        }

        public Criteria andUpperAmounyIn(List<Long> values) {
            addCriterion("upper_amouny in", values, "upperAmouny");
            return (Criteria) this;
        }

        public Criteria andUpperAmounyNotIn(List<Long> values) {
            addCriterion("upper_amouny not in", values, "upperAmouny");
            return (Criteria) this;
        }

        public Criteria andUpperAmounyBetween(Long value1, Long value2) {
            addCriterion("upper_amouny between", value1, value2, "upperAmouny");
            return (Criteria) this;
        }

        public Criteria andUpperAmounyNotBetween(Long value1, Long value2) {
            addCriterion("upper_amouny not between", value1, value2, "upperAmouny");
            return (Criteria) this;
        }

        public Criteria andFormalitiesTypeIsNull() {
            addCriterion("formalities_type is null");
            return (Criteria) this;
        }

        public Criteria andFormalitiesTypeIsNotNull() {
            addCriterion("formalities_type is not null");
            return (Criteria) this;
        }

        public Criteria andFormalitiesTypeEqualTo(String value) {
            addCriterion("formalities_type =", value, "formalitiesType");
            return (Criteria) this;
        }

        public Criteria andFormalitiesTypeNotEqualTo(String value) {
            addCriterion("formalities_type <>", value, "formalitiesType");
            return (Criteria) this;
        }

        public Criteria andFormalitiesTypeGreaterThan(String value) {
            addCriterion("formalities_type >", value, "formalitiesType");
            return (Criteria) this;
        }

        public Criteria andFormalitiesTypeGreaterThanOrEqualTo(String value) {
            addCriterion("formalities_type >=", value, "formalitiesType");
            return (Criteria) this;
        }

        public Criteria andFormalitiesTypeLessThan(String value) {
            addCriterion("formalities_type <", value, "formalitiesType");
            return (Criteria) this;
        }

        public Criteria andFormalitiesTypeLessThanOrEqualTo(String value) {
            addCriterion("formalities_type <=", value, "formalitiesType");
            return (Criteria) this;
        }

        public Criteria andFormalitiesTypeLike(String value) {
            addCriterion("formalities_type like", value, "formalitiesType");
            return (Criteria) this;
        }

        public Criteria andFormalitiesTypeNotLike(String value) {
            addCriterion("formalities_type not like", value, "formalitiesType");
            return (Criteria) this;
        }

        public Criteria andFormalitiesTypeIn(List<String> values) {
            addCriterion("formalities_type in", values, "formalitiesType");
            return (Criteria) this;
        }

        public Criteria andFormalitiesTypeNotIn(List<String> values) {
            addCriterion("formalities_type not in", values, "formalitiesType");
            return (Criteria) this;
        }

        public Criteria andFormalitiesTypeBetween(String value1, String value2) {
            addCriterion("formalities_type between", value1, value2, "formalitiesType");
            return (Criteria) this;
        }

        public Criteria andFormalitiesTypeNotBetween(String value1, String value2) {
            addCriterion("formalities_type not between", value1, value2, "formalitiesType");
            return (Criteria) this;
        }

        public Criteria andFormalitiesModeIsNull() {
            addCriterion("formalities_mode is null");
            return (Criteria) this;
        }

        public Criteria andFormalitiesModeIsNotNull() {
            addCriterion("formalities_mode is not null");
            return (Criteria) this;
        }

        public Criteria andFormalitiesModeEqualTo(String value) {
            addCriterion("formalities_mode =", value, "formalitiesMode");
            return (Criteria) this;
        }

        public Criteria andFormalitiesModeNotEqualTo(String value) {
            addCriterion("formalities_mode <>", value, "formalitiesMode");
            return (Criteria) this;
        }

        public Criteria andFormalitiesModeGreaterThan(String value) {
            addCriterion("formalities_mode >", value, "formalitiesMode");
            return (Criteria) this;
        }

        public Criteria andFormalitiesModeGreaterThanOrEqualTo(String value) {
            addCriterion("formalities_mode >=", value, "formalitiesMode");
            return (Criteria) this;
        }

        public Criteria andFormalitiesModeLessThan(String value) {
            addCriterion("formalities_mode <", value, "formalitiesMode");
            return (Criteria) this;
        }

        public Criteria andFormalitiesModeLessThanOrEqualTo(String value) {
            addCriterion("formalities_mode <=", value, "formalitiesMode");
            return (Criteria) this;
        }

        public Criteria andFormalitiesModeLike(String value) {
            addCriterion("formalities_mode like", value, "formalitiesMode");
            return (Criteria) this;
        }

        public Criteria andFormalitiesModeNotLike(String value) {
            addCriterion("formalities_mode not like", value, "formalitiesMode");
            return (Criteria) this;
        }

        public Criteria andFormalitiesModeIn(List<String> values) {
            addCriterion("formalities_mode in", values, "formalitiesMode");
            return (Criteria) this;
        }

        public Criteria andFormalitiesModeNotIn(List<String> values) {
            addCriterion("formalities_mode not in", values, "formalitiesMode");
            return (Criteria) this;
        }

        public Criteria andFormalitiesModeBetween(String value1, String value2) {
            addCriterion("formalities_mode between", value1, value2, "formalitiesMode");
            return (Criteria) this;
        }

        public Criteria andFormalitiesModeNotBetween(String value1, String value2) {
            addCriterion("formalities_mode not between", value1, value2, "formalitiesMode");
            return (Criteria) this;
        }

        public Criteria andSingleProportionIsNull() {
            addCriterion("single_proportion is null");
            return (Criteria) this;
        }

        public Criteria andSingleProportionIsNotNull() {
            addCriterion("single_proportion is not null");
            return (Criteria) this;
        }

        public Criteria andSingleProportionEqualTo(Integer value) {
            addCriterion("single_proportion =", value, "singleProportion");
            return (Criteria) this;
        }

        public Criteria andSingleProportionNotEqualTo(Integer value) {
            addCriterion("single_proportion <>", value, "singleProportion");
            return (Criteria) this;
        }

        public Criteria andSingleProportionGreaterThan(Integer value) {
            addCriterion("single_proportion >", value, "singleProportion");
            return (Criteria) this;
        }

        public Criteria andSingleProportionGreaterThanOrEqualTo(Integer value) {
            addCriterion("single_proportion >=", value, "singleProportion");
            return (Criteria) this;
        }

        public Criteria andSingleProportionLessThan(Integer value) {
            addCriterion("single_proportion <", value, "singleProportion");
            return (Criteria) this;
        }

        public Criteria andSingleProportionLessThanOrEqualTo(Integer value) {
            addCriterion("single_proportion <=", value, "singleProportion");
            return (Criteria) this;
        }

        public Criteria andSingleProportionIn(List<Integer> values) {
            addCriterion("single_proportion in", values, "singleProportion");
            return (Criteria) this;
        }

        public Criteria andSingleProportionNotIn(List<Integer> values) {
            addCriterion("single_proportion not in", values, "singleProportion");
            return (Criteria) this;
        }

        public Criteria andSingleProportionBetween(Integer value1, Integer value2) {
            addCriterion("single_proportion between", value1, value2, "singleProportion");
            return (Criteria) this;
        }

        public Criteria andSingleProportionNotBetween(Integer value1, Integer value2) {
            addCriterion("single_proportion not between", value1, value2, "singleProportion");
            return (Criteria) this;
        }

        public Criteria andSingleCostIsNull() {
            addCriterion("single_cost is null");
            return (Criteria) this;
        }

        public Criteria andSingleCostIsNotNull() {
            addCriterion("single_cost is not null");
            return (Criteria) this;
        }

        public Criteria andSingleCostEqualTo(Integer value) {
            addCriterion("single_cost =", value, "singleCost");
            return (Criteria) this;
        }

        public Criteria andSingleCostNotEqualTo(Integer value) {
            addCriterion("single_cost <>", value, "singleCost");
            return (Criteria) this;
        }

        public Criteria andSingleCostGreaterThan(Integer value) {
            addCriterion("single_cost >", value, "singleCost");
            return (Criteria) this;
        }

        public Criteria andSingleCostGreaterThanOrEqualTo(Integer value) {
            addCriterion("single_cost >=", value, "singleCost");
            return (Criteria) this;
        }

        public Criteria andSingleCostLessThan(Integer value) {
            addCriterion("single_cost <", value, "singleCost");
            return (Criteria) this;
        }

        public Criteria andSingleCostLessThanOrEqualTo(Integer value) {
            addCriterion("single_cost <=", value, "singleCost");
            return (Criteria) this;
        }

        public Criteria andSingleCostIn(List<Integer> values) {
            addCriterion("single_cost in", values, "singleCost");
            return (Criteria) this;
        }

        public Criteria andSingleCostNotIn(List<Integer> values) {
            addCriterion("single_cost not in", values, "singleCost");
            return (Criteria) this;
        }

        public Criteria andSingleCostBetween(Integer value1, Integer value2) {
            addCriterion("single_cost between", value1, value2, "singleCost");
            return (Criteria) this;
        }

        public Criteria andSingleCostNotBetween(Integer value1, Integer value2) {
            addCriterion("single_cost not between", value1, value2, "singleCost");
            return (Criteria) this;
        }

        public Criteria andTransferNoRebateIsNull() {
            addCriterion("transfer_no_rebate is null");
            return (Criteria) this;
        }

        public Criteria andTransferNoRebateIsNotNull() {
            addCriterion("transfer_no_rebate is not null");
            return (Criteria) this;
        }

        public Criteria andTransferNoRebateEqualTo(Integer value) {
            addCriterion("transfer_no_rebate =", value, "transferNoRebate");
            return (Criteria) this;
        }

        public Criteria andTransferNoRebateNotEqualTo(Integer value) {
            addCriterion("transfer_no_rebate <>", value, "transferNoRebate");
            return (Criteria) this;
        }

        public Criteria andTransferNoRebateGreaterThan(Integer value) {
            addCriterion("transfer_no_rebate >", value, "transferNoRebate");
            return (Criteria) this;
        }

        public Criteria andTransferNoRebateGreaterThanOrEqualTo(Integer value) {
            addCriterion("transfer_no_rebate >=", value, "transferNoRebate");
            return (Criteria) this;
        }

        public Criteria andTransferNoRebateLessThan(Integer value) {
            addCriterion("transfer_no_rebate <", value, "transferNoRebate");
            return (Criteria) this;
        }

        public Criteria andTransferNoRebateLessThanOrEqualTo(Integer value) {
            addCriterion("transfer_no_rebate <=", value, "transferNoRebate");
            return (Criteria) this;
        }

        public Criteria andTransferNoRebateIn(List<Integer> values) {
            addCriterion("transfer_no_rebate in", values, "transferNoRebate");
            return (Criteria) this;
        }

        public Criteria andTransferNoRebateNotIn(List<Integer> values) {
            addCriterion("transfer_no_rebate not in", values, "transferNoRebate");
            return (Criteria) this;
        }

        public Criteria andTransferNoRebateBetween(Integer value1, Integer value2) {
            addCriterion("transfer_no_rebate between", value1, value2, "transferNoRebate");
            return (Criteria) this;
        }

        public Criteria andTransferNoRebateNotBetween(Integer value1, Integer value2) {
            addCriterion("transfer_no_rebate not between", value1, value2, "transferNoRebate");
            return (Criteria) this;
        }

        public Criteria andTransferNoMoneyIsNull() {
            addCriterion("transfer_no_money is null");
            return (Criteria) this;
        }

        public Criteria andTransferNoMoneyIsNotNull() {
            addCriterion("transfer_no_money is not null");
            return (Criteria) this;
        }

        public Criteria andTransferNoMoneyEqualTo(Integer value) {
            addCriterion("transfer_no_money =", value, "transferNoMoney");
            return (Criteria) this;
        }

        public Criteria andTransferNoMoneyNotEqualTo(Integer value) {
            addCriterion("transfer_no_money <>", value, "transferNoMoney");
            return (Criteria) this;
        }

        public Criteria andTransferNoMoneyGreaterThan(Integer value) {
            addCriterion("transfer_no_money >", value, "transferNoMoney");
            return (Criteria) this;
        }

        public Criteria andTransferNoMoneyGreaterThanOrEqualTo(Integer value) {
            addCriterion("transfer_no_money >=", value, "transferNoMoney");
            return (Criteria) this;
        }

        public Criteria andTransferNoMoneyLessThan(Integer value) {
            addCriterion("transfer_no_money <", value, "transferNoMoney");
            return (Criteria) this;
        }

        public Criteria andTransferNoMoneyLessThanOrEqualTo(Integer value) {
            addCriterion("transfer_no_money <=", value, "transferNoMoney");
            return (Criteria) this;
        }

        public Criteria andTransferNoMoneyIn(List<Integer> values) {
            addCriterion("transfer_no_money in", values, "transferNoMoney");
            return (Criteria) this;
        }

        public Criteria andTransferNoMoneyNotIn(List<Integer> values) {
            addCriterion("transfer_no_money not in", values, "transferNoMoney");
            return (Criteria) this;
        }

        public Criteria andTransferNoMoneyBetween(Integer value1, Integer value2) {
            addCriterion("transfer_no_money between", value1, value2, "transferNoMoney");
            return (Criteria) this;
        }

        public Criteria andTransferNoMoneyNotBetween(Integer value1, Integer value2) {
            addCriterion("transfer_no_money not between", value1, value2, "transferNoMoney");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}